Views

A view can be thought of as either a virtual table or a stored query. Unless a view is indexed, its data is not stored in the database as a distinct object. What is stored in the database is a SELECT statement. The result set of the SELECT statement forms the virtual table returned by the view. A user can use this virtual table by referencing the view name in Transact-SQL statements the same way a table is referenced.

Just simply click to open an object pane for View. By using the object pane toolbar below, you can create new, edit, open and delete the selected view.

Create View

To create a new view

To create a new view with the same properties as one of the existing views has (using popup menu)

Apply to: current database {same connection}

To create a new view with the same properties as one of the existing views has (using drag and drop method)

Apply to: current database {same connection}
Apply to: different database {same connection}
  different database {different connection} (Data Transfer tool will be activated)
  • Select the view(s) for copying in the object pane.
  • Drag and drop the chosen view(s) to the target database.
  • Select one of the following options:

    • Copy
    • Cancel

To create a new view with modification as one of the existing views

To create a new view with loading from a SQL file

Edit View

To edit the existing view (manage its SQL definition etc)

To change the name of the view

Open View

To open a view (manage view data)

Delete View

To delete a view

Achieve View Information

To achieve a view information